public DataTable FlexFieldInsert(string TokenName, int IsRequired, long CreatedBy, long? AtulProcessID, long? AtulSubProcessID, long? AtulActivityID)
{
if (AtulProcessID == 0)
{
AtulProcessID = null;
}
if (AtulSubProcessID == 0)
{
AtulSubProcessID = null;
}
if (AtulActivityID == 0)
{
AtulActivityID = null;
}
SqlCommand cmd = new SqlCommand("exec dbo.Atul_FlexFieldInsert_sp @TokenName, @IsRequired, @CreatedBy, @AtulProcessID, @AtulSubProcessID, @AtulActivityID", this._connection);
cmd.Parameters.Add(new SqlParameter("@TokenName", TokenName));
cmd.Parameters.Add(new SqlParameter("@IsRequired", IsRequired));
cmd.Parameters.Add(new SqlParameter("@CreatedBy", CreatedBy));
cmd.Parameters.Add(new SqlParameter("@AtulProcessID", AtulProcessID));
cmd.Parameters.Add(new SqlParameter("@AtulSubProcessID", AtulSubProcessID));
cmd.Parameters.Add(new SqlParameter("@AtulActivityID", AtulActivityID));
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
DataTable returnTable = new DataTable(); returnTable.TableName = "FlexFieldUpsert";
da.Fill(returnTable);
return returnTable;
}