// ---------------------------------------------------------------------------------------
public DataTable FindLastNo(PlMovePhotos pl)
{
cmd = new SqlCommand("SPPhotoMove", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", pl.Ind);
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
return(dt);
}
DataSet MoveImgaes(string DestFilePath, string SrcFilePath)
{
plMovePhotos = new PlMovePhotos()
{
Ind = 9,
PartNoFrom = Convert.ToInt32(txtPartFrom.Text),
PartNoTo = Convert.ToInt32(txtPartTo.Text),
DestPath = DestFilePath,
SourcePath = SrcFilePath,
};
return(blMovePhotos.MoveImages(plMovePhotos));
}
// ---------------------------------------------------------------------------------------
public int GetPartNoFromTo(PlMovePhotos pl)
{
cmd = new SqlCommand("SPPhotoMove", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", pl.Ind);
cmd.Parameters.AddWithValue("@PartNoFrom", pl.PartNoFrom);
cmd.Parameters.AddWithValue("@PartNoTo", pl.PartNoTo);
con.Open();
int i = Convert.ToInt32(cmd.ExecuteScalar());
con.Close();
return(i);
}
public DataSet MoveImages(PlMovePhotos pl)
{
cmd = new SqlCommand("SPPhotoMove", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", pl.Ind);
cmd.Parameters.AddWithValue("@DestPath", pl.DestPath);
cmd.Parameters.AddWithValue("@SourcePath", pl.SourcePath);
cmd.Parameters.AddWithValue("@PartNoFrom", pl.PartNoFrom);
cmd.Parameters.AddWithValue("@PartNoTo", pl.PartNoTo);
da = new SqlDataAdapter(cmd);
ds = new DataSet();
da.Fill(ds);
return(ds);
}
public int UpdateRemainingPart(PlMovePhotos pl)
{
cmd = new SqlCommand("SPPhotoMove", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", pl.Ind);
cmd.Parameters.AddWithValue("@PartNoFrom", pl.PartNoFrom);
cmd.Parameters.AddWithValue("@PartNoTo", pl.PartNoTo);
cmd.Parameters.AddWithValue("@RemainingParts", pl.RemainingPart);
cmd.Parameters.AddWithValue("@MoveDate", pl.MoveDate);
cmd.Parameters.AddWithValue("@TotalImagesCopied", pl.TotalImagesCopied);
con.Open();
int i = cmd.ExecuteNonQuery();
con.Close();
return(i);
}
public int InsertDestPath(PlMovePhotos pl)
{
cmd = new SqlCommand("SPPhotoMove", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", pl.Ind);
cmd.Parameters.AddWithValue("@PartType", pl.Ind);
cmd.Parameters.AddWithValue("@SourcePath", pl.SourcePath);
cmd.Parameters.AddWithValue("@DestPath", pl.DestPath);
cmd.Parameters.AddWithValue("@PartNoFrom", pl.PartNoFrom);
cmd.Parameters.AddWithValue("@PartNoTo", pl.PartNoTo);
cmd.Parameters.AddWithValue("@RemainingParts", pl.RemainingPart);
con.Open();
int i = cmd.ExecuteNonQuery();
con.Close();
return(i);
}
// ---------------------------------------------------------------------------------------
public DataTable FindLastNo(PlMovePhotos pl)
{
return(dl.FindLastNo(pl));
}
public DataSet MoveImages(PlMovePhotos pl)
{
return(dl.MoveImages(pl));
}
public int UpdateRemainingPart(PlMovePhotos pl)
{
return(dl.UpdateRemainingPart(pl));
}
// ---------------------------------------------------------------------------------------
public int GetPartNoFromTo(PlMovePhotos pl)
{
return(dl.GetPartNoFromTo(pl));
}
public DataTable GetMachineName(PlMovePhotos pl)
{
return(dl.GetMachineName(pl));
}
public int InsertDestPath(PlMovePhotos pl)
{
return(dl.InsertDestPath(pl));
}
public DataTable GetDestPath(PlMovePhotos pl)
{
return(dl.GetDestPath(pl));
}
