private GrantCodeMster AddGrantCodeMaster(GrantCodeMster grantCodeMster) { string insertProcedure = "[CreateGrantCodeMaster]"; SqlCommand insertCommand = new SqlCommand(insertProcedure, connection); insertCommand.CommandType = CommandType.StoredProcedure; if (grantCodeMster.GrantId != 0) { insertCommand.Parameters.AddWithValue("@GrantId", grantCodeMster.GrantId); } else { insertCommand.Parameters.AddWithValue("@GrantId", 0); } if (!string.IsNullOrEmpty(grantCodeMster.GrantTitle)) { insertCommand.Parameters.AddWithValue("@GrantTitle", grantCodeMster.GrantTitle); } else { insertCommand.Parameters.AddWithValue("@GrantTitle", DBNull.Value); } if (grantCodeMster.CustId != 0) { insertCommand.Parameters.AddWithValue("@CustId", grantCodeMster.CustId); } else { insertCommand.Parameters.AddWithValue("@CustId", 0); } if (grantCodeMster.isRequired) { insertCommand.Parameters.AddWithValue("@isRequired", grantCodeMster.isRequired); } else { insertCommand.Parameters.AddWithValue("@isRequired", 0); } if (grantCodeMster.fldlength != 0) { insertCommand.Parameters.AddWithValue("@fldlength", grantCodeMster.fldlength); } else { insertCommand.Parameters.AddWithValue("@fldlength", 0); } if (grantCodeMster.Serial != 0) { insertCommand.Parameters.AddWithValue("@Serial", grantCodeMster.Serial); } else { insertCommand.Parameters.AddWithValue("@Serial", 0); } if (grantCodeMster.DependOn != 0) { insertCommand.Parameters.AddWithValue("@DependOn", grantCodeMster.DependOn); } else { insertCommand.Parameters.AddWithValue("@DependOn", 0); } if (grantCodeMster.IsActive) { insertCommand.Parameters.AddWithValue("@IsActive", grantCodeMster.IsActive); } else { insertCommand.Parameters.AddWithValue("@IsActive", 0); } if (grantCodeMster.Type != 0) { insertCommand.Parameters.AddWithValue("@StatementType", grantCodeMster.Type); } else { insertCommand.Parameters.AddWithValue("@StatementType", 0); } if (grantCodeMster.UserID != 0) { insertCommand.Parameters.AddWithValue("@UserID", grantCodeMster.UserID); } else { insertCommand.Parameters.AddWithValue("@UserID", 0); } insertCommand.Parameters.Add("@GrantIdout", System.Data.SqlDbType.Int); insertCommand.Parameters["@GrantIdout"].Direction = ParameterDirection.Output; insertCommand.Parameters.Add("@ReturnValue", System.Data.SqlDbType.Int); insertCommand.Parameters["@ReturnValue"].Direction = ParameterDirection.Output; try { int count = 0; connection.Open(); insertCommand.ExecuteNonQuery(); if (insertCommand.Parameters["@ReturnValue"].Value != DBNull.Value) { count = System.Convert.ToInt32(insertCommand.Parameters["@ReturnValue"].Value); grantCodeMster.Status = count; } if (count == 1 && grantCodeMster.GrantId == 0) { grantCodeMster.GrantId = System.Convert.ToInt32(insertCommand.Parameters["@GrantIdout"].Value); } return(grantCodeMster); } catch (Exception ex) { log.logErrorMessage(""); log.logErrorMessage(ex.StackTrace); return(grantCodeMster); } finally { connection.Close(); } }
public List <dynamic> AddGrantBudget(GrantBudgeMster grantBudgeMster) { List <dynamic> objDynamic = new List <dynamic>(); GrantBudgetCodeMster grantBudgetCodeMster = new GrantBudgetCodeMster(); switch (grantBudgeMster.value) { case 1: { GrantCodeMster grantCodeMster = new GrantCodeMster(); var Data = JsonConvert.DeserializeObject <List <GrantBudgetCodeMster> >(grantBudgeMster.GrantBudgeMsterlist); for (int i = 0; i < Data.Count; i++) { grantBudgetCodeMster = Data[i]; if (grantBudgetCodeMster.Ischange) { if (!String.IsNullOrEmpty(grantBudgetCodeMster.GrantBudgetTitle)) { if (!string.IsNullOrEmpty(UserID)) { grantCodeMster.UserID = Convert.ToInt64(UserID); } grantCodeMster.GrantId = grantBudgetCodeMster.GrantBudgetId; grantCodeMster.GrantTitle = grantBudgetCodeMster.GrantBudgetTitle; grantCodeMster.fldlength = grantBudgetCodeMster.fldlength; grantCodeMster.isRequired = grantBudgetCodeMster.isRequired; grantCodeMster.Serial = grantBudgetCodeMster.Serial; grantCodeMster.DependOn = grantBudgetCodeMster.DependOn; grantCodeMster.IsActive = grantBudgetCodeMster.IsActive; grantCodeMster.CustId = grantBudgeMster.CustId; if (grantBudgetCodeMster.GrantBudgetId == 0) { grantCodeMster.Type = 1; grantCodeMster.IsActive = true; } else { grantCodeMster.Type = 2; } if (grantBudgetCodeMster.IsDelete == true) { grantCodeMster.Type = 3; grantCodeMster.IsActive = false; } AddGrantCodeMaster(grantCodeMster); if (grantCodeMster.Status == -99) { break; } } else { } } } objDynamic.Add(grantCodeMster.Status); objDynamic.Add(GetGrantcodeMasterData(grantBudgeMster.CustId)); break; } case 2: { BudgetCodeMasterDTO budgetCodeMasterDTO = new BudgetCodeMasterDTO(); try { var Data = JsonConvert.DeserializeObject <List <GrantBudgetCodeMster> >(grantBudgeMster.GrantBudgeMsterlist); for (int j = 0; j < Data.Count; j++) { grantBudgetCodeMster = Data[j]; if (grantBudgetCodeMster.Ischange) { if (!String.IsNullOrEmpty(grantBudgetCodeMster.GrantBudgetTitle)) { if (!string.IsNullOrEmpty(UserID)) { budgetCodeMasterDTO.UserID = Convert.ToInt64(UserID); } budgetCodeMasterDTO.BudgetId = grantBudgetCodeMster.GrantBudgetId; budgetCodeMasterDTO.BudgetTitle = grantBudgetCodeMster.GrantBudgetTitle; budgetCodeMasterDTO.FldLength = grantBudgetCodeMster.fldlength; budgetCodeMasterDTO.isRequired = grantBudgetCodeMster.isRequired; budgetCodeMasterDTO.Serial = grantBudgetCodeMster.Serial; budgetCodeMasterDTO.DependOn = grantBudgetCodeMster.DependOn; budgetCodeMasterDTO.IsActive = grantBudgetCodeMster.IsActive; budgetCodeMasterDTO.CustId = grantBudgeMster.CustId; if (grantBudgetCodeMster.GrantBudgetId == 0) { budgetCodeMasterDTO.Type = 1; budgetCodeMasterDTO.IsActive = true; } else { budgetCodeMasterDTO.Type = 2; } if (grantBudgetCodeMster.IsDelete == true) { budgetCodeMasterDTO.Type = 3; budgetCodeMasterDTO.IsActive = false; } AddBudgetCodeMaster(budgetCodeMasterDTO); if (budgetCodeMasterDTO.Status == -99) { break; } } else { } } } objDynamic.Add(budgetCodeMasterDTO.Status); objDynamic.Add(GetBudgetCodeData(grantBudgeMster.CustId)); } catch (Exception ex) { } break; } } return(objDynamic); }