public bool DeleteMArea(MArea marea)
{
SqlCommand cmd;
cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "DeleteMArea";
cmd.Parameters.AddWithValue("@AreaNo", marea.AreaNo);
if (ObjTrans.ExecuteNonQuery(cmd, CommonFunctions.ConStr) == true)
{
return(true);
}
else
{
marea.msg = ObjTrans.ErrorMessage;
return(false);
}
}
public bool AddMArea(MArea marea)
{
SqlCommand cmd;
cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "AddMArea";
cmd.Parameters.AddWithValue("@AreaNo", marea.AreaNo);
cmd.Parameters.AddWithValue("@AreaName", marea.AreaName);
cmd.Parameters.AddWithValue("@AreaLangName", marea.AreaLangName);
cmd.Parameters.AddWithValue("@AreaShortCode", marea.AreaShortCode);
// cmd.Parameters.AddWithValue("@CountryNo", marea.CountryNo);
// cmd.Parameters.AddWithValue("@StateNo", marea.StateNo);
//cmd.Parameters.AddWithValue("@CityNo", marea.CityNo);
// cmd.Parameters.AddWithValue("@RegionNo", marea.RegionNo);
cmd.Parameters.AddWithValue("@IsActive", marea.IsActive);
cmd.Parameters.AddWithValue("@UserID", marea.UserID);
cmd.Parameters.AddWithValue("@UserDate", marea.UserDate);
cmd.Parameters.AddWithValue("@CompanyNo", marea.CompanyNo);
//cmd.Parameters.AddWithValue("@ModifiedBy", marea.ModifiedBy);
if (ObjTrans.ExecuteNonQuery(cmd, CommonFunctions.ConStr) == true)
{
return(true);
}
else
{
marea.msg = ObjTrans.ErrorMessage;
return(false);
}
}
public MArea ModifyMAreaByID(long ID)
{
SqlConnection Con = new SqlConnection(CommonFunctions.ConStr);
string sql;
SqlCommand cmd;
sql = "Select * from MArea where AreaNo =" + 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)
{
MArea MM = new MArea();
while (dr.Read())
{
MM.AreaNo = Convert.ToInt32(dr["AreaNo"]);
if (!Convert.IsDBNull(dr["AreaName"]))
{
MM.AreaName = Convert.ToString(dr["AreaName"]);
}
if (!Convert.IsDBNull(dr["AreaLangName"]))
{
MM.AreaLangName = Convert.ToString(dr["AreaLangName"]);
}
if (!Convert.IsDBNull(dr["AreaShortCode"]))
{
MM.AreaShortCode = Convert.ToString(dr["AreaShortCode"]);
}
// if (!Convert.IsDBNull(dr["CountryNo"])) MM.CountryNo = Convert.ToInt64(dr["CountryNo"]);
// 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["RegionNo"])) MM.RegionNo = Convert.ToInt64(dr["RegionNo"]);
if (!Convert.IsDBNull(dr["IsActive"]))
{
MM.IsActive = Convert.ToBoolean(dr["IsActive"]);
}
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["CompanyNo"]))
{
MM.CompanyNo = Convert.ToInt64(dr["CompanyNo"]);
}
}
dr.Close();
return(MM);
}
else
{
dr.Close();
}
return(new MArea());
}
