public bool DeleteMState(MState mstate)
{
SqlCommand cmd;
cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "DeleteMState";
cmd.Parameters.AddWithValue("@StateNo", mstate.StateNo);
if (ObjTrans.ExecuteNonQuery(cmd, CommonFunctions.ConStr) == true)
{
return(true);
}
else
{
mstate.msg = ObjTrans.ErrorMessage;
return(false);
}
}
public bool AddMState(MState mstate)
{
SqlCommand cmd;
cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "AddMState";
cmd.Parameters.AddWithValue("@StateNo", mstate.StateNo);
cmd.Parameters.AddWithValue("@StateName", mstate.StateName);
cmd.Parameters.AddWithValue("@StateShortCode", mstate.StateShortCode);
cmd.Parameters.AddWithValue("@StateLangName", mstate.StateLangName);
cmd.Parameters.AddWithValue("@CountryNo", mstate.CountryNo);
cmd.Parameters.AddWithValue("@IsActive", mstate.IsActive);
cmd.Parameters.AddWithValue("@UserID", mstate.UserID);
cmd.Parameters.AddWithValue("@UserDate", mstate.UserDate);
cmd.Parameters.AddWithValue("@CompanyNo", mstate.CompanyNo);
cmd.Parameters.AddWithValue("@StateCode", mstate.StateCode);
//cmd.Parameters.AddWithValue("@ModifiedBy", mstate.ModifiedBy);
if (ObjTrans.ExecuteNonQuery(cmd, CommonFunctions.ConStr) == true)
{
return(true);
}
else
{
mstate.msg = ObjTrans.ErrorMessage;
return(false);
}
}
public MState ModifyMStateByID(long ID)
{
SqlConnection Con = new SqlConnection(CommonFunctions.ConStr);
string sql;
SqlCommand cmd;
sql = "Select * from MState where StateNo =" + 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)
{
MState MM = new MState();
while (dr.Read())
{
MM.StateNo = Convert.ToInt32(dr["StateNo"]);
if (!Convert.IsDBNull(dr["StateName"]))
{
MM.StateName = Convert.ToString(dr["StateName"]);
}
if (!Convert.IsDBNull(dr["StateShortCode"]))
{
MM.StateShortCode = Convert.ToString(dr["StateShortCode"]);
}
if (!Convert.IsDBNull(dr["StateLangName"]))
{
MM.StateLangName = Convert.ToString(dr["StateLangName"]);
}
if (!Convert.IsDBNull(dr["CountryNo"]))
{
MM.CountryNo = Convert.ToInt64(dr["CountryNo"]);
}
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"]);
}
if (!Convert.IsDBNull(dr["StateCode"]))
{
MM.StateCode = Convert.ToString(dr["StateCode"]);
}
}
dr.Close();
return(MM);
}
else
{
dr.Close();
}
return(new MState());
}
