public bool AddMFirm(MFirm Mfirm)
{
SqlCommand cmd;
cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "AddMFirm";
cmd.Parameters.AddWithValue("@FirmNo", Mfirm.FirmNo);
cmd.Parameters.AddWithValue("@FirmName", Mfirm.FirmName);
cmd.Parameters.AddWithValue("@ShortName", Mfirm.ShortName);
cmd.Parameters.AddWithValue("@Address", Mfirm.Address);
cmd.Parameters.AddWithValue("@StateNo", Mfirm.StateNo);
cmd.Parameters.AddWithValue("@StateCode", Mfirm.StateCode);
cmd.Parameters.AddWithValue("@CityNo", Mfirm.CityNo);
cmd.Parameters.AddWithValue("@Pincode", Mfirm.Pincode);
cmd.Parameters.AddWithValue("@EmailID", Mfirm.EmailID);
cmd.Parameters.AddWithValue("@PhoneNo1", Mfirm.PhoneNo1);
cmd.Parameters.AddWithValue("@PhoneNo2", Mfirm.PhoneNo2);
cmd.Parameters.AddWithValue("@MobileNo1", Mfirm.MobileNo1);
cmd.Parameters.AddWithValue("@MobileNo2", Mfirm.MobileNo2);
cmd.Parameters.AddWithValue("@TermAndCondition", Mfirm.TermAndCondition);
cmd.Parameters.AddWithValue("@GSTNo", Mfirm.GSTNo);
cmd.Parameters.AddWithValue("@FSSAINo", Mfirm.FSSAINo);
cmd.Parameters.AddWithValue("@PANNo", Mfirm.PANNo);
cmd.Parameters.AddWithValue("@AdharNo", Mfirm.AdharNo);
cmd.Parameters.AddWithValue("@AnyotherNo1", Mfirm.AnyotherNo1);
cmd.Parameters.AddWithValue("@AnyotherNo2", Mfirm.AnyotherNo2);
cmd.Parameters.AddWithValue("@GSTDate", Mfirm.GSTDate);
cmd.Parameters.AddWithValue("@FSSAIDate", Mfirm.FSSAIDate);
cmd.Parameters.AddWithValue("@IsType", Mfirm.IsType);
cmd.Parameters.AddWithValue("@IsActive", Mfirm.IsActive);
cmd.Parameters.AddWithValue("@UserID", Mfirm.UserID);
cmd.Parameters.AddWithValue("@UserDate", Mfirm.UserDate);
cmd.Parameters.AddWithValue("@PrinterName", Mfirm.PrinterName);
cmd.Parameters.AddWithValue("@CompanyType", Mfirm.CompanyType);
//---GST--//
SqlParameter outParameter = new SqlParameter();
outParameter.ParameterName = "@ReturnID";
outParameter.Direction = ParameterDirection.Output;
outParameter.DbType = DbType.Int32;
cmd.Parameters.Add(outParameter);
commandcollection.Add(cmd);
return(true);
}
public bool DeleteMFirm(MFirm mFirm)
{
SqlCommand cmd;
cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "DeleteMFirm";
cmd.Parameters.AddWithValue("@FirmNo", mFirm.FirmNo);
if (ObjTrans.ExecuteNonQuery(cmd, CommonFunctions.ConStr) == true)
{
return(true);
}
else
{
mFirm.msg = ObjTrans.ErrorMessage;
return(false);
}
}
public MFirm ModifyMFirmByID(long ID)
{
SqlConnection Con = new SqlConnection(CommonFunctions.ConStr);
string sql;
SqlCommand cmd;
sql = "Select * from MFirm where FirmNo =" + ID;
cmd = new SqlCommand(sql, Con);
cmd.Connection = Con;
Con.Open();
cmd.CommandType = CommandType.Text;
SqlDataReader dr;
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
if (dr.HasRows)
{
MFirm MM = new MFirm();
while (dr.Read())
{
MM.FirmNo = Convert.ToInt32(dr["FirmNo"]);
if (!Convert.IsDBNull(dr["FirmName"]))
{
MM.FirmName = Convert.ToString(dr["FirmName"]);
}
if (!Convert.IsDBNull(dr["ShortName"]))
{
MM.ShortName = Convert.ToString(dr["ShortName"]);
}
if (!Convert.IsDBNull(dr["EmailID"]))
{
MM.EmailID = Convert.ToString(dr["EmailID"]);
}
if (!Convert.IsDBNull(dr["PrinterName"]))
{
MM.PrinterName = Convert.ToString(dr["PrinterName"]);
}
if (!Convert.IsDBNull(dr["Address"]))
{
MM.Address = Convert.ToString(dr["Address"]);
}
if (!Convert.IsDBNull(dr["PhoneNo1"]))
{
MM.PhoneNo1 = Convert.ToString(dr["PhoneNo1"]);
}
if (!Convert.IsDBNull(dr["PhoneNo2"]))
{
MM.PhoneNo2 = Convert.ToString(dr["PhoneNo2"]);
}
if (!Convert.IsDBNull(dr["MobileNo1"]))
{
MM.MobileNo1 = Convert.ToString(dr["MobileNo1"]);
}
if (!Convert.IsDBNull(dr["MobileNo2"]))
{
MM.MobileNo2 = Convert.ToString(dr["MobileNo2"]);
}
if (!Convert.IsDBNull(dr["StateNo"]))
{
MM.StateNo = Convert.ToInt64(dr["StateNo"]);
}
if (!Convert.IsDBNull(dr["CityNo"]))
{
MM.CityNo = Convert.ToInt64(dr["CityNo"]);
}
if (!Convert.IsDBNull(dr["Pincode"]))
{
MM.Pincode = Convert.ToString(dr["Pincode"]);
}
if (!Convert.IsDBNull(dr["TermAndCondition"]))
{
MM.TermAndCondition = Convert.ToString(dr["TermAndCondition"]);
}
if (!Convert.IsDBNull(dr["GSTNO"]))
{
MM.GSTNo = Convert.ToString(dr["GSTNO"]);
}
if (!Convert.IsDBNull(dr["GSTDate"]))
{
MM.GSTDate = Convert.ToDateTime(dr["GSTDate"]);
}
if (!Convert.IsDBNull(dr["FSSAIDate"]))
{
MM.FSSAIDate = Convert.ToDateTime(dr["FSSAIDate"]);
}
if (!Convert.IsDBNull(dr["FSSAINo"]))
{
MM.FSSAINo = Convert.ToString(dr["FSSAINo"]);
}
if (!Convert.IsDBNull(dr["PANCardNo"]))
{
MM.PANNo = Convert.ToString(dr["PANCardNo"]);
}
if (!Convert.IsDBNull(dr["AdharCardNo"]))
{
MM.AdharNo = Convert.ToString(dr["AdharCardNo"]);
}
if (!Convert.IsDBNull(dr["AnyotherNo1"]))
{
MM.AnyotherNo1 = Convert.ToString(dr["AnyotherNo1"]);
}
if (!Convert.IsDBNull(dr["AnyotherNo2"]))
{
MM.AnyotherNo2 = Convert.ToString(dr["AnyotherNo2"]);
}
if (!Convert.IsDBNull(dr["IsActive"]))
{
MM.IsActive = Convert.ToBoolean(dr["IsActive"]);
}
if (!Convert.IsDBNull(dr["IsType"]))
{
MM.IsType = Convert.ToBoolean(dr["IsType"]);
}
if (!Convert.IsDBNull(dr["UserID"]))
{
MM.UserID = Convert.ToInt64(dr["UserID"]);
}
if (!Convert.IsDBNull(dr["UserDate"]))
{
MM.UserDate = Convert.ToDateTime(dr["UserDate"]);
}
if (!Convert.IsDBNull(dr["ModifiedBy"]))
{
MM.ModifiedBy = Convert.ToString(dr["ModifiedBy"]);
}
if (!Convert.IsDBNull(dr["StateCode"]))
{
MM.StateCode = Convert.ToInt32(dr["StateCode"]);
}
if (!Convert.IsDBNull(dr["CompanyType"]))
{
MM.CompanyType = Convert.ToInt32(dr["CompanyType"]);
}
}
dr.Close();
return(MM);
}
else
{
dr.Close();
}
return(new MFirm());
}
