public string CheckIfCargoRateSettingsExists(ACRF_CargoRateSettingsModel objModel) { string result = ""; try { string sqlstr = "Select * from ACRF_CargoRateSettings Where ISNULL(Rate1,0)=@Rate1 and isnull(Rate2,0)=@Rate2 " + " and isnull(Rate3,'') =@Rate3"; var connection = gConnection.Connection(); connection.Open(); SqlCommand cmd = new SqlCommand(sqlstr, connection); cmd.Parameters.AddWithValue("@Rate1", objModel.Rate1); cmd.Parameters.AddWithValue("@Rate2", objModel.Rate2); cmd.Parameters.AddWithValue("@Rate3", objModel.Rate3); SqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read()) { result = "CargoRateSettings already exists!"; } sdr.Close(); connection.Close(); } catch (Exception ex) { ErrorHandlerClass.LogError(ex); } return(result); }
private ACRF_CargoRateSettingsModel NullToBlank(ACRF_CargoRateSettingsModel objModel) { if (objModel.Rate1 == null) { objModel.Rate1 = 0; } if (objModel.Rate2 == null) { objModel.Rate2 = 0; } if (objModel.Rate3 == null) { objModel.Rate3 = 0; } if (objModel.DisplayRate1 == null) { objModel.DisplayRate1 = ""; } if (objModel.DisplayRate2 == null) { objModel.DisplayRate2 = ""; } if (objModel.DisplayRate3 == null) { objModel.DisplayRate3 = ""; } return(objModel); }
public IHttpActionResult ViewOneCargoRateSettings(int Id) { ACRF_CargoRateSettingsModel objList = new ACRF_CargoRateSettingsModel(); try { objList = objCrRtVM.GetOneCargoRateSettings(Id); } catch (Exception ex) { ErrorHandlerClass.LogError(ex); } return(Ok(new { results = objList })); }
public ACRF_CargoRateSettingsModel GetOneCargoRateSettings(int id) { ACRF_CargoRateSettingsModel objModel = new ACRF_CargoRateSettingsModel(); try { string sqlstr = "select Id, isnull(Rate1,0) as Rate1, isnull(Rate2,0) as Rate2,isnull(Rate3,'0') as Rate3,IsRate1,IsRate2,IsRate3,VendorId,CreatedBy,CreatedOn,DisplayRate1,DisplayRate2,DisplayRate3 " + " from ACRF_CargoRateSettings where VendorId=@Id"; var connection = gConnection.Connection(); connection.Open(); SqlCommand cmd = new SqlCommand(sqlstr, connection); cmd.CommandType = System.Data.CommandType.Text; cmd.Parameters.AddWithValue("@Id", id); SqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read()) { objModel.Id = Convert.ToInt32(sdr["Id"].ToString()); objModel.Rate1 = Convert.ToInt32(sdr["Rate1"]); objModel.Rate2 = Convert.ToInt32(sdr["Rate2"]); objModel.Rate3 = Convert.ToInt32(sdr["Rate3"]); objModel.IsRate1 = Convert.ToBoolean(sdr["IsRate1"].ToString()); objModel.IsRate2 = Convert.ToBoolean(sdr["IsRate2"].ToString()); objModel.IsRate3 = Convert.ToBoolean(sdr["IsRate3"].ToString()); objModel.VendorId = Convert.ToInt32(sdr["VendorId"].ToString()); objModel.CreatedBy = sdr["CreatedBy"].ToString(); objModel.CreatedOn = Convert.ToDateTime(sdr["CreatedOn"].ToString()); objModel.DisplayRate1 = sdr["DisplayRate1"].ToString(); objModel.DisplayRate2 = sdr["DisplayRate2"].ToString(); objModel.DisplayRate3 = sdr["DisplayRate3"].ToString(); } sdr.Close(); connection.Close(); } catch (Exception ex) { ErrorHandlerClass.LogError(ex); } return(objModel); }
public IHttpActionResult UpdateCargoRateSettings(ACRF_CargoRateSettingsModel objModel) { string result = ""; if (ModelState.IsValid) { try { objModel.UpdatedBy = GlobalFunction.getLoggedInUser(Request.Headers.GetValues("Token").First()); result = objCrRtVM.UpdateCargoRateSettings(objModel); } catch (Exception ex) { ErrorHandlerClass.LogError(ex); result = ex.Message; } } else { result = "Enter Valid Mandatory Fields"; } return(Ok(new { results = result })); }
public string UpdateCargoRateSettings(ACRF_CargoRateSettingsModel objModel) { string result = "Error on Updating Airlines!"; try { objModel = NullToBlank(objModel); result = CheckIfCargoRateSettingsExists(objModel); if (result == "") { var connection = gConnection.Connection(); connection.Open(); SqlCommand cmd = connection.CreateCommand(); SqlTransaction transaction; transaction = connection.BeginTransaction(); cmd.Transaction = transaction; cmd.Connection = connection; try { string sqlstr = ""; sqlstr = "update ACRF_CargoRateSettings set Rate1=@Rate1,Rate2=@Rate2,Rate3=@Rate3,UpdatedBy=@UpdatedBy,UpdatedOn=@UpdatedOn,IsRate1=@IsRate1,IsRate2=@IsRate2,IsRate3=@IsRate3,DisplayRate1=@DisplayRate1,DisplayRate2=@DisplayRate2,DisplayRate3=@DisplayRate3" + " where VendorId=@Id"; cmd.CommandText = sqlstr; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@Rate1", objModel.Rate1); cmd.Parameters.AddWithValue("@Rate2", objModel.Rate2); cmd.Parameters.AddWithValue("@Rate3", objModel.Rate3); cmd.Parameters.AddWithValue("@Id", objModel.VendorId); cmd.Parameters.AddWithValue("@UpdatedBy", objModel.CreatedBy); cmd.Parameters.AddWithValue("@UpdatedOn", StandardDateTime.GetDateTime()); cmd.Parameters.AddWithValue("@IsRate1", objModel.IsRate1); cmd.Parameters.AddWithValue("@IsRate2", objModel.IsRate2); cmd.Parameters.AddWithValue("@IsRate3", objModel.IsRate3); cmd.Parameters.AddWithValue("@DisplayRate1", objModel.DisplayRate1); cmd.Parameters.AddWithValue("@DisplayRate2", objModel.DisplayRate2); cmd.Parameters.AddWithValue("@DisplayRate3", objModel.DisplayRate3); cmd.ExecuteNonQuery(); transaction.Commit(); connection.Close(); result = "Cargoratesettings Updated Successfully!"; } catch (Exception ex) { transaction.Rollback(); connection.Close(); Global.ErrorHandlerClass.LogError(ex); result = ex.Message; } } else { return(result); } } catch (Exception ex) { ErrorHandlerClass.LogError(ex); } return(result); }
public string CreateCargoRateSettings(ACRF_CargoRateSettingsModel objModel) { string result = "Error on Saving Cargo Rates!"; try { objModel = NullToBlank(objModel); result = CheckIfCargoRateSettingsExists(objModel); if (result == "") { var connection = gConnection.Connection(); connection.Open(); SqlCommand cmd = connection.CreateCommand(); SqlTransaction transaction; transaction = connection.BeginTransaction(); cmd.Transaction = transaction; cmd.Connection = connection; try { string sqlstr = ""; sqlstr = "insert into ACRF_CargoRateSettings(Rate1,Rate2,Rate3,CreatedBy,CreatedOn,IsRate1,IsRate2,IsRate3,VendorId,DisplayRate1," + " DisplayRate2,DisplayRate3) values (@Rate1,@Rate2,@Rate3,@CreatedBy,@CreatedOn,@IsRate1,@IsRate2,@IsRate3,@VendorId,@DisplayRate1," + " @DisplayRate2,@DisplayRate3)"; cmd.CommandText = sqlstr; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@Rate1", objModel.Rate1); cmd.Parameters.AddWithValue("@Rate2", objModel.Rate2); cmd.Parameters.AddWithValue("@Rate3", objModel.Rate3); cmd.Parameters.AddWithValue("@CreatedBy", objModel.CreatedBy); cmd.Parameters.AddWithValue("@CreatedOn", StandardDateTime.GetDateTime()); cmd.Parameters.AddWithValue("@IsRate1", objModel.IsRate1); cmd.Parameters.AddWithValue("@IsRate2", objModel.IsRate2); cmd.Parameters.AddWithValue("@IsRate3", objModel.IsRate3); cmd.Parameters.AddWithValue("@VendorId", objModel.VendorId); cmd.Parameters.AddWithValue("@DisplayRate1", objModel.DisplayRate1); cmd.Parameters.AddWithValue("@DisplayRate2", objModel.DisplayRate2); cmd.Parameters.AddWithValue("@DisplayRate3", objModel.DisplayRate3); cmd.ExecuteNonQuery(); transaction.Commit(); connection.Close(); result = "CargoRateSettings Added Successfully!"; } catch (Exception ex) { transaction.Rollback(); connection.Close(); Global.ErrorHandlerClass.LogError(ex); result = ex.Message; } } else { return(result); } } catch (Exception ex) { ErrorHandlerClass.LogError(ex); } return(result); }