private static PrepaidBottleType FillDataRecord(IDataRecord dr)
{
PrepaidBottleType pBType = new PrepaidBottleType();
pBType.TypeID = dr.GetInt32(dr.GetOrdinal("TypeID"));
pBType.Name = dr.GetString(dr.GetOrdinal("Name"));
pBType.Description = dr.GetString(dr.GetOrdinal("Description"));
pBType.CreatedDate = dr.GetDateTime(dr.GetOrdinal("CreatedDate"));
pBType.ModifiedDate = dr.GetDateTime(dr.GetOrdinal("ModifiedDate"));
pBType.CreatedBy = dr.GetString(dr.GetOrdinal("CreatedBy"));
pBType.ModifiedBy = dr.GetString(dr.GetOrdinal("ModifiedBy"));
return(pBType);
}
public static int Save(PrepaidBottleType pBType)
{
int result;
MyDBConnection myConn = new MyDBConnection();
SqlConnection conn = new SqlConnection();
try
{
conn = myConn.OpenDB();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "dbo.InsertUpdatePBType";
if (pBType.TypeID == -1)
{
cmd.Parameters.Add("@TypeID", SqlDbType.Int).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add("@TypeID", SqlDbType.Int).Value = pBType.TypeID;
}
cmd.Parameters.Add("@Name", SqlDbType.VarChar).Value = pBType.Name;
cmd.Parameters.Add("@Description", SqlDbType.VarChar).Value = pBType.Description;
cmd.Parameters.Add("@CreatedDate", SqlDbType.DateTime).Value = pBType.CreatedDate;
cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = pBType.ModifiedDate;
cmd.Parameters.Add("@CreatedBy", SqlDbType.VarChar).Value = pBType.CreatedBy;
cmd.Parameters.Add("@ModifiedBy", SqlDbType.VarChar).Value = pBType.ModifiedBy;
DbParameter returnValue = cmd.CreateParameter();
returnValue.Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add(returnValue);
cmd.ExecuteNonQuery();
result = Convert.ToInt32(returnValue.Value);
cmd.Dispose();
}
finally
{
myConn.CloseDB(conn);
}
return(result);
}
