private int UpdateBudgetCodeMaster(BudgetCodeMasterDTO budgetCodeMaster) { int BudgetId = 0; string updateProcedure = "[CreateNewBudgetCodeMaster]"; SqlCommand updateCommand = new SqlCommand(updateProcedure, connection); updateCommand.CommandType = CommandType.StoredProcedure; if (budgetCodeMaster.BudgetId != 0) { updateCommand.Parameters.AddWithValue("@BudgetId", budgetCodeMaster.BudgetId); } else { updateCommand.Parameters.AddWithValue("@BudgetId", 0); } if (!string.IsNullOrEmpty(budgetCodeMaster.BudgetTitle)) { updateCommand.Parameters.AddWithValue("@BudgetTitle", budgetCodeMaster.BudgetTitle); } else { updateCommand.Parameters.AddWithValue("@BudgetTitle", DBNull.Value); } if (budgetCodeMaster.CustId != 0) { updateCommand.Parameters.AddWithValue("@CustId", budgetCodeMaster.CustId); } else { updateCommand.Parameters.AddWithValue("@CustId", 0); } if (budgetCodeMaster.isRequired) { updateCommand.Parameters.AddWithValue("@isRequired", budgetCodeMaster.isRequired); } else { updateCommand.Parameters.AddWithValue("@isRequired", 0); } if (budgetCodeMaster.FldLength != 0) { updateCommand.Parameters.AddWithValue("@FldLength", budgetCodeMaster.FldLength); } else { updateCommand.Parameters.AddWithValue("@FldLength", 0); } if (budgetCodeMaster.Serial != 0) { updateCommand.Parameters.AddWithValue("@Serial ", budgetCodeMaster.Serial); } else { updateCommand.Parameters.AddWithValue("@Serial ", 0); } if (budgetCodeMaster.DependOn != 0) { updateCommand.Parameters.AddWithValue("@DependOn ", budgetCodeMaster.DependOn); } else { updateCommand.Parameters.AddWithValue("@DependOn ", 0); } updateCommand.Parameters.Add("@ReturnValue", System.Data.SqlDbType.Int); updateCommand.Parameters["@ReturnValue"].Direction = ParameterDirection.Output; try { int count = 0; connection.Open(); updateCommand.ExecuteNonQuery(); if (updateCommand.Parameters["@ReturnValue"].Value != DBNull.Value) { count = System.Convert.ToInt32(updateCommand.Parameters["@ReturnValue"].Value); } return(BudgetId); } catch (Exception ex) { log.logErrorMessage(""); log.logErrorMessage(ex.StackTrace); return(BudgetId); } 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); }