public bool DeleteTEWayDetails(TEWayDetails tewaydetails)
{
SqlCommand cmd;
cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "DeleteTEWayDetails";
cmd.Parameters.AddWithValue("@PKEWayNo", tewaydetails.PKEWayNo);
if (ObjTrans.ExecuteNonQuery(cmd, CommonFunctions.ConStr) == true)
{
return(true);
}
else
{
tewaydetails.msg = ObjTrans.ErrorMessage;
return(false);
}
}
public bool AddTEWayDetails(TEWayDetails tewaydetails)
{
SqlCommand cmd;
cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "AddTEWayDetails";
cmd.Parameters.AddWithValue("@PKEWayNo", tewaydetails.PKEWayNo);
cmd.Parameters.AddWithValue("@FkVoucherNo", tewaydetails.FkVoucherNo);
cmd.Parameters.AddWithValue("@EWayNo", tewaydetails.EWayNo);
cmd.Parameters.AddWithValue("@VoucherUserNo", tewaydetails.VoucherUserNo);
cmd.Parameters.AddWithValue("@EWayDate", tewaydetails.EWayDate);
cmd.Parameters.AddWithValue("@ModeNo", tewaydetails.ModeNo);
cmd.Parameters.AddWithValue("@Distance", tewaydetails.Distance);
cmd.Parameters.AddWithValue("@TransportNo", tewaydetails.TransportNo);
cmd.Parameters.AddWithValue("@VehicleNo", tewaydetails.VehicleNo);
cmd.Parameters.AddWithValue("@LRNo", tewaydetails.LRNo);
cmd.Parameters.AddWithValue("@LRDate", tewaydetails.LRDate);
cmd.Parameters.AddWithValue("@LedgerNo", tewaydetails.LedgerNo);
cmd.Parameters.AddWithValue("@LedgerName", tewaydetails.LedgerName);
cmd.Parameters.AddWithValue("@Address", tewaydetails.Address);
cmd.Parameters.AddWithValue("@CityNo", tewaydetails.CityNo);
cmd.Parameters.AddWithValue("@CityName", tewaydetails.CityName);
cmd.Parameters.AddWithValue("@PinCode", tewaydetails.PinCode);
cmd.Parameters.AddWithValue("@StateCode", tewaydetails.StateCode);
cmd.Parameters.AddWithValue("@StateName", tewaydetails.StateName);
cmd.Parameters.AddWithValue("@UserID", tewaydetails.UserID);
cmd.Parameters.AddWithValue("@UserDate", tewaydetails.UserDate);
//cmd.Parameters.AddWithValue("@ModifiedBy", tewaydetails.ModifiedBy);
cmd.Parameters.AddWithValue("@StatusNo", tewaydetails.StatusNo);
cmd.Parameters.AddWithValue("@IsActive", tewaydetails.IsActive);
cmd.Parameters.AddWithValue("@TranspotorNm", tewaydetails.TranspotorNm);
if (ObjTrans.ExecuteNonQuery(cmd, CommonFunctions.ConStr) == true)
{
return(true);
}
else
{
tewaydetails.msg = ObjTrans.ErrorMessage;
return(false);
}
}
//public DataView GetAllMArea()
//{
// SqlConnection Con = new SqlConnection(CommonFunctions.ConStr);
// string sql = "Select * from MArea order by AreaNo";
// SqlDataAdapter da = new SqlDataAdapter(sql, Con);
// DataSet ds = new DataSet();
// try
// {
// da.Fill(ds);
// }
// catch { throw; }
// finally
// {
// Con.Close();
// }
// return ds.Tables[(0)].DefaultView;
//}
public TEWayDetails ModifyTEWayDetailsByID(long ID)
{
SqlConnection Con = new SqlConnection(CommonFunctions.ConStr);
string sql;
SqlCommand cmd;
sql = "Select * from TEWayDetails where FkVoucherNo = " + 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)
{
TEWayDetails MM = new TEWayDetails();
while (dr.Read())
{
MM.PKEWayNo = Convert.ToInt64(dr["PKEWayNo"]);
if (!Convert.IsDBNull(dr["FkVoucherNo"]))
{
MM.FkVoucherNo = Convert.ToInt32(dr["FkVoucherNo"]);
}
if (!Convert.IsDBNull(dr["EWayNo"]))
{
MM.EWayNo = Convert.ToString(dr["EWayNo"]);
}
if (!Convert.IsDBNull(dr["VoucherUserNo"]))
{
MM.VoucherUserNo = Convert.ToInt64(dr["VoucherUserNo"]);
}
if (!Convert.IsDBNull(dr["EWayDate"]))
{
MM.EWayDate = Convert.ToDateTime(dr["EWayDate"]);
}
if (!Convert.IsDBNull(dr["ModeNo"]))
{
MM.ModeNo = Convert.ToInt64(dr["ModeNo"]);
}
if (!Convert.IsDBNull(dr["Distance"]))
{
MM.Distance = Convert.ToDouble(dr["Distance"]);
}
if (!Convert.IsDBNull(dr["TransportNo"]))
{
MM.TransportNo = Convert.ToInt64(dr["TransportNo"]);
}
if (!Convert.IsDBNull(dr["VehicleNo"]))
{
MM.VehicleNo = Convert.ToString(dr["VehicleNo"]);
}
if (!Convert.IsDBNull(dr["LRNo"]))
{
MM.LRNo = Convert.ToString(dr["LRNo"]);
}
if (!Convert.IsDBNull(dr["LRDate"]))
{
MM.LRDate = Convert.ToDateTime(dr["LRDate"]);
}
if (!Convert.IsDBNull(dr["LedgerNo"]))
{
MM.LedgerNo = Convert.ToInt32(dr["LedgerNo"]);
}
if (!Convert.IsDBNull(dr["LedgerName"]))
{
MM.LedgerName = Convert.ToString(dr["LedgerName"]);
}
if (!Convert.IsDBNull(dr["Address"]))
{
MM.Address = Convert.ToString(dr["Address"]);
}
if (!Convert.IsDBNull(dr["CityNo"]))
{
MM.CityNo = Convert.ToInt64(dr["CityNo"]);
}
if (!Convert.IsDBNull(dr["CityName"]))
{
MM.CityName = Convert.ToString(dr["CityName"]);
}
if (!Convert.IsDBNull(dr["PinCode"]))
{
MM.PinCode = Convert.ToInt64(dr["PinCode"]);
}
if (!Convert.IsDBNull(dr["StateCode"]))
{
MM.StateCode = Convert.ToInt64(dr["StateCode"]);
}
if (!Convert.IsDBNull(dr["StateName"]))
{
MM.StateName = Convert.ToString(dr["StateName"]);
}
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["StatusNo"]))
{
MM.StatusNo = Convert.ToInt32(dr["StatusNo"]);
}
if (!Convert.IsDBNull(dr["IsActive"]))
{
MM.Address = Convert.ToString(dr["IsActive"]);
}
if (!Convert.IsDBNull(dr["TranspotorNm"]))
{
MM.TranspotorNm = Convert.ToString(dr["TranspotorNm"]);
}
}
dr.Close();
return(MM);
}
else
{
dr.Close();
}
return(new TEWayDetails());
}
