public bool DeleteMCompany(MCompany mcompany) { SqlCommand cmd = null; cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "DeleteMCompany"; cmd.Parameters.AddWithValue("@CompanyNo", mcompany.CompanyNo); if (ObjTrans.ExecuteNonQuery(cmd, CommonFunctions.ConStr) == true) { return(true); } else { mcompany.msg = ObjTrans.ErrorMessage; return(false); } }
public bool AddMCompany(MCompany mcompany) { SqlCommand cmd = null; cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "AddMCompany"; cmd.Parameters.AddWithValue("@CompanyNo", mcompany.CompanyNo); cmd.Parameters.AddWithValue("@RegistrationNo", mcompany.RegistrationNo); cmd.Parameters.AddWithValue("@CompanyUserCode", mcompany.CompanyUserCode); cmd.Parameters.AddWithValue("@CompanyName", mcompany.CompanyName); cmd.Parameters.AddWithValue("@AddressCode", mcompany.AddressCode); cmd.Parameters.AddWithValue("@PhoneNo", mcompany.PhoneNo); cmd.Parameters.AddWithValue("@CityCode", mcompany.CityCode); cmd.Parameters.AddWithValue("@PinCode", mcompany.PinCode); //cmd.Parameters.AddWithValue("@FinancialYear", mcompany.FinancialYear); //cmd.Parameters.AddWithValue("@BooksBeginFrom", mcompany.BooksBeginFrom); //cmd.Parameters.AddWithValue("@BooksEndOn", mcompany.BooksEndOn); cmd.Parameters.AddWithValue("@Config", mcompany.Config); cmd.Parameters.AddWithValue("@CSTNo", mcompany.CSTNo); cmd.Parameters.AddWithValue("@BSTNo", mcompany.BSTNo); cmd.Parameters.AddWithValue("@TinNo", mcompany.TinNo); cmd.Parameters.AddWithValue("@IncomeTaxNo", mcompany.IncomeTaxNo); cmd.Parameters.AddWithValue("@VatNo", mcompany.VatNo); cmd.Parameters.AddWithValue("@CurrencySymbol", mcompany.CurrencySymbol); cmd.Parameters.AddWithValue("@MailingName", mcompany.MailingName); cmd.Parameters.AddWithValue("@MaintainCode", mcompany.MaintainCode); cmd.Parameters.AddWithValue("@BaseCurrencySymbol", mcompany.BaseCurrencySymbol); cmd.Parameters.AddWithValue("@FormalName", mcompany.FormalName); cmd.Parameters.AddWithValue("@NoOfDecimalPlaces", mcompany.NoOfDecimalPlaces); cmd.Parameters.AddWithValue("@SymbolSuffixed", mcompany.SymbolSuffixed); cmd.Parameters.AddWithValue("@AmountInMillion", mcompany.AmountInMillion); cmd.Parameters.AddWithValue("@SpaceBetweenAmountAndSymbol", mcompany.SpaceBetweenAmountAndSymbol); cmd.Parameters.AddWithValue("@UICulture", mcompany.UICulture); cmd.Parameters.AddWithValue("@FontName", mcompany.FontName); cmd.Parameters.AddWithValue("@FontSize1", mcompany.FontSize1); cmd.Parameters.AddWithValue("@FontSize2", mcompany.FontSize2); //cmd.Parameters.AddWithValue("@ModifiedBy", mcompany.ModifiedBy); cmd.Parameters.AddWithValue("@LogoPath", mcompany.LogoPath); cmd.Parameters.AddWithValue("@Narr_Head", mcompany.Narr_Head); cmd.Parameters.AddWithValue("@Narr_Foot", mcompany.Narr_Foot); cmd.Parameters.AddWithValue("@Narr_Terms", mcompany.Narr_Terms); cmd.Parameters.AddWithValue("@CompanyType", mcompany.CompanyType); cmd.Parameters.AddWithValue("@LBTNo", mcompany.LBTNo); //---GST--// cmd.Parameters.AddWithValue("@StateCode", mcompany.StateCode); if (ObjTrans.ExecuteNonQuery(cmd, CommonFunctions.ConStr) == true) { return(true); } else { mcompany.msg = ObjTrans.ErrorMessage; return(false); } }
public MCompany ModifyMCompanyByID(int ID) { SqlConnection Con = new SqlConnection(CommonFunctions.ConStr); string sql = null; SqlCommand cmd = null; sql = "Select * from MCompany where CompanyNo =" + ID; cmd = new SqlCommand(sql, Con); cmd.Connection = Con; Con.Open(); cmd.CommandType = CommandType.Text; SqlDataReader dr = null; dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); if (dr.HasRows) { MCompany MM = new MCompany(); while (dr.Read()) { MM.CompanyNo = Convert.ToInt32(dr["CompanyNo"]); if (!(Convert.IsDBNull(dr["RegistrationNo"]))) { MM.RegistrationNo = Convert.ToInt64(dr["RegistrationNo"]); } if (!(Convert.IsDBNull(dr["CompanyUserCode"]))) { MM.CompanyUserCode = Convert.ToString(dr["CompanyUserCode"]); } if (!(Convert.IsDBNull(dr["CompanyName"]))) { MM.CompanyName = Convert.ToString(dr["CompanyName"]); } if (!(Convert.IsDBNull(dr["AddressCode"]))) { MM.AddressCode = Convert.ToString(dr["AddressCode"]); } if (!(Convert.IsDBNull(dr["PhoneNo"]))) { MM.PhoneNo = Convert.ToString(dr["PhoneNo"]); } if (!(Convert.IsDBNull(dr["CityCode"]))) { MM.CityCode = Convert.ToInt64(dr["CityCode"]); } if (!(Convert.IsDBNull(dr["PinCode"]))) { MM.PinCode = Convert.ToString(dr["PinCode"]); } if (!(Convert.IsDBNull(dr["FinancialYear"]))) { MM.FinancialYear = Convert.ToDateTime(dr["FinancialYear"]); } if (!(Convert.IsDBNull(dr["BooksBeginFrom"]))) { MM.BooksBeginFrom = Convert.ToDateTime(dr["BooksBeginFrom"]); } if (!(Convert.IsDBNull(dr["BooksEndOn"]))) { MM.BooksEndOn = Convert.ToDateTime(dr["BooksEndOn"]); } if (!(Convert.IsDBNull(dr["Config"]))) { MM.Config = Convert.ToString(dr["Config"]); } if (!(Convert.IsDBNull(dr["CSTNo"]))) { MM.CSTNo = Convert.ToString(dr["CSTNo"]); } if (!(Convert.IsDBNull(dr["BSTNo"]))) { MM.BSTNo = Convert.ToString(dr["BSTNo"]); } if (!(Convert.IsDBNull(dr["TinNo"]))) { MM.TinNo = Convert.ToString(dr["TinNo"]); } if (!(Convert.IsDBNull(dr["IncomeTaxNo"]))) { MM.IncomeTaxNo = Convert.ToString(dr["IncomeTaxNo"]); } if (!(Convert.IsDBNull(dr["VatNo"]))) { MM.VatNo = Convert.ToString(dr["VatNo"]); } if (!(Convert.IsDBNull(dr["CurrencySymbol"]))) { MM.CurrencySymbol = Convert.ToString(dr["CurrencySymbol"]); } if (!(Convert.IsDBNull(dr["MailingName"]))) { MM.MailingName = Convert.ToString(dr["MailingName"]); } if (!(Convert.IsDBNull(dr["MaintainCode"]))) { MM.MaintainCode = Convert.ToInt64(dr["MaintainCode"]); } if (!(Convert.IsDBNull(dr["BaseCurrencySymbol"]))) { MM.BaseCurrencySymbol = Convert.ToString(dr["BaseCurrencySymbol"]); } if (!(Convert.IsDBNull(dr["FormalName"]))) { MM.FormalName = Convert.ToString(dr["FormalName"]); } if (!(Convert.IsDBNull(dr["NoOfDecimalPlaces"]))) { MM.NoOfDecimalPlaces = Convert.ToInt32(dr["NoOfDecimalPlaces"]); } if (!(Convert.IsDBNull(dr["SymbolSuffixed"]))) { MM.SymbolSuffixed = Convert.ToInt32(dr["SymbolSuffixed"]); } if (!(Convert.IsDBNull(dr["AmountInMillion"]))) { MM.AmountInMillion = Convert.ToInt32(dr["AmountInMillion"]); } if (!(Convert.IsDBNull(dr["SpaceBetweenAmountAndSymbol"]))) { MM.SpaceBetweenAmountAndSymbol = Convert.ToInt32(dr["SpaceBetweenAmountAndSymbol"]); } if (!(Convert.IsDBNull(dr["UICulture"]))) { MM.UICulture = Convert.ToString(dr["UICulture"]); } if (!(Convert.IsDBNull(dr["FontName"]))) { MM.FontName = Convert.ToString(dr["FontName"]); } if (!(Convert.IsDBNull(dr["FontSize1"]))) { MM.FontSize1 = Convert.ToInt32(dr["FontSize1"]); } if (!(Convert.IsDBNull(dr["FontSize2"]))) { MM.FontSize2 = Convert.ToInt32(dr["FontSize2"]); } if (!(Convert.IsDBNull(dr["ModifiedBy"]))) { MM.ModifiedBy = Convert.ToString(dr["ModifiedBy"]); } if (!(Convert.IsDBNull(dr["LogoPath"]))) { MM.LogoPath = Convert.ToString(dr["LogoPath"]); } if (!(Convert.IsDBNull(dr["Narr_Head"]))) { MM.Narr_Head = Convert.ToString(dr["Narr_Head"]); } if (!(Convert.IsDBNull(dr["Narr_Foot"]))) { MM.Narr_Foot = Convert.ToString(dr["Narr_Foot"]); } if (!(Convert.IsDBNull(dr["Narr_Terms"]))) { MM.Narr_Terms = Convert.ToString(dr["Narr_Terms"]); } if (!(Convert.IsDBNull(dr["CompanyType"]))) { MM.CompanyType = Convert.ToInt32(dr["CompanyType"]); } if (!(Convert.IsDBNull(dr["LBTNo"]))) { MM.LBTNo = Convert.ToString(dr["LBTNo"]); } if (!(Convert.IsDBNull(dr["StateCode"]))) { MM.StateCode = Convert.ToInt32(dr["StateCode"]); } } dr.Close(); return(MM); } else { dr.Close(); } return(new MCompany()); }