public void UpdateDistrictInfo(District_NameBO objBO, int districtId) { string QueryString = ""; string QueryStringBankBranchRoutingInfoUpdate = ""; QueryString = @"UPDATE SBP_District_Info SET [District_Code]='" + objBO.District_Code + "'" + ",[District_Name]='" + objBO.DistrictName + "'" + ",[Description]='" + objBO.District_Description + "'" + " WHERE ID=" + districtId; QueryStringBankBranchRoutingInfoUpdate = @"UPDATE dbo.SBP_Bank_Branch_Routing_Info SET [District_Code]='" + objBO.District_Code + "'" + ",[District_Name]='" + objBO.DistrictName + "'" + " WHERE [District_ID]=" + districtId; try { _dbConnection.ConnectDatabase(); _dbConnection.StartTransaction(); _dbConnection.ExecuteNonQuery(QueryString); _dbConnection.ExecuteNonQuery(QueryStringBankBranchRoutingInfoUpdate); _dbConnection.Commit(); } catch (Exception ex) { _dbConnection.Rollback(); throw ex; } finally { _dbConnection.CloseDatabase(); } }
public void SaveDistrictName(District_NameBO objBO) { string QueryString = ""; QueryString = @"INSERT INTO SBP_District_Info ( [District_Code] , [District_Name] , [Description] , [Entry_Date] , [Entry_By] ) VALUES (" + objBO.District_Code + ",'" + objBO.DistrictName + "'" + ",'" + objBO.District_Description + "'" + ",(CAST(FLOOR(CAST(GETDATE() AS FLOAT)) AS DATETIME))" + ",'" + GlobalVariableBO._userName + "'" + ")"; try { _dbConnection.ConnectDatabase(); _dbConnection.ExecuteNonQuery(QueryString); } catch (Exception ex) { throw ex; } finally { _dbConnection.CloseDatabase(); } }